AmHighSchool 
Logical Entity Name  AmHighSchool 
Default Table Name  AmHighSchool 
Physical Only  NO 
Definition 
 
Note 
 

AmHighSchool Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Code    char(16)  NO 
 
SyCampusGrpID    int  NO 
 
Descrip    varchar(60)  NO 
 
Addr1    varchar(255)  NO 
 
Addr2    varchar(35)  NO 
 
City    varchar(35)  NO 
 
State    char(2)  NO 
 
Zip    char(10)  YES 
 
Country    varchar(10)  YES 
 
Phone    char(16)  NO 
 
FaxNo    char(16)  NO 
 
Contact1    varchar(25)  NO 
 
Title1    varchar(10)  NO 
 
EMail1    varchar(50)  NO 
 
Contact2    char(25)  NO 
 
Title2    varchar(10)  NO 
 
EMail2    varchar(50)  NO 
 
Comments    text  YES 
 
Active    bit  NO 
 
ModFlag    char(1)  NO 
 
Userid    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  YES 
 
AMHighSchoolID(PK)    int  NO 
 
SyCountryID    int  YES 
 
TranscriptOfficeAddr    varchar(255)  YES 
 
TranscriptOfficeCity    varchar(25)  YES 
 
TranscriptOfficeState    char(2)  YES 
 
TranscriptOfficeSyCountryID(FK)    int  YES 
 
TranscriptOfficeZip    char(10)  YES 
 
TranscriptOfficePhone    char(16)  YES 
 
TranscriptOfficeFax    char(16)  YES 
 
TranscriptContact    varchar(100)  YES 
 
TranscriptFee    money  YES 
 
SyCountyID    int  YES 
 
Email    varchar(50)  YES 
 
URL    varchar(50)  YES 
 
DrivingDirections    ntext  YES 
 
SyOrganizationID(FK)    int  YES 
 
AcadYearEnd    int  YES 
 
CrmSuppressFlag    bit  NO 
 
SyNexusOrganizationId(FK)    int  YES 
 

AmHighSchool Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_AmHighSchool2  PrimaryKey  AMHighSchoolID 

AmHighSchool Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyNexusOrganization  Non-Identifying  Zero or One to Zero or More  FK_AmHighSchool_SyNexusOrganizationId_SyNexusOrganization_SyNexusOrganizationId      SyNexusOrganizationId  NO  YES 
SyOrganization  Non-Identifying  Zero or One to Zero or More  FK_AmHighSchool_SyOrganizationID_SyOrganization_SyOrganizationID      SyOrganizationID  NO  YES 
SyCountry  Non-Identifying  Zero or One to Zero or More  FK_AmHighSchool_TranscriptOfficeSyCountryID_SyCountry_SyCountryID      TranscriptOfficeSyCountryID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdEnrollSched  Non-Identifying  One To Zero or More  FK_AdEnrollSchedAmHighSchoolID_AmHighSchoolAmHighSchoolID        NO  YES 
AmApplicant  Non-Identifying  One To Zero or More  FK_AmApplicant_AmHighSchoolID_AmHighSchool_AmHighSchoolID        NO  YES 
AmCollegeTransfer  Non-Identifying  One To Zero or More  FK_AmCollegeTransferAmHighSchoolID_AmHighSchoolAmHighSchoolID        NO  YES 
AmCollegeTransferExternalCourse  Non-Identifying  One To Zero or More  FK_AmCollegeTransferExternalCourse_AmHighSchoolID_AmHighSchool_AmHighSchoolID        NO  YES 
AmHighSchoolCourse  Non-Identifying  One To Zero or More  FK_AmHighSchoolCourseAmHighSchoolID_AmHighSchoolAmHighSchoolID        NO  YES 
AmHighSchoolExternalMap  Non-Identifying  One To Zero or More  FK_AmHighSchoolExternalMapAmHighSchoolID_AmHighSchoolAmHighSchoolID        NO  YES 
AmProspectPrevEduc  Non-Identifying  One To Zero or More  FK_AmProspectPrevEduc_AmHighSchoolId_AmHighSchool_AmHighSchoolID        NO  YES 
CmDocumentTranscript  Non-Identifying  One To Zero or More  FK_CmDocumentTranscript_AmHighSchoolID_AmHighSchool_AMHighSchoolID        NO  YES 

AmHighSchool Check Constraints 
Check Constraint Name  CheckConstraint